﻿/*
 *  ChgDoc CMS - GNU General Public License, version 3 (GPL-3.0)
 *  Copyright (C)  2012. Ian Quigley
 *  
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *  
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 */

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using SqliteORM;

namespace ChgDoc.Entity
{
    public enum EntityType
    {
        Article = 1
    }

    [Table]
    public class EntityAttribute : TableBase<EntityAttribute>
    {
        [PrimaryKey( true )]
        public long Id { get; set; }

        [Field]
        public long EntityId { get; set; }

        [Field]
        public EntityType Entity { get; set; }

        [Field]
        public string Code { get; set; }

        [Field]
        public string Value { get; set; }

        internal static List<EntityAttribute> ReadAll(EntityType entity, long entityId)
        {
            return Get(ad => ad.Select().Where(Where.And(Where.Equal("Entity", (int)entity), Where.Equal("EntityId", entityId))).ToList());
        }

        internal static List<string> DistinctCodesFor(EntityType entityType)
        {   
            List<string> result = new List<string>();

            using (var adapter = new DirectSql())
            {
                adapter.Execute("Select distinct Code from EntityAttribute where Entity = " + (int)entityType, arr =>
                    {
                        result.Add((string)arr[0]);
                        return true;
                    });
            }
            return result;
        }

        internal static void Delete( EntityType entityType, string code )
        {
            Do( ad => ad.Delete( Where.And( Where.Equal( "Entity", entityType ), Where.Equal( "Code", code ) ) ) );
        }

        internal static EntityAttribute Find(EntityType entityType, long entityId, string code )
        {
            return Get( ad => ad.Select().Where( Where.And( Where.Equal( "Entity", entityType), Where.Equal( "EntityId", entityId ), Where.Equal( "Code", code ) ) ).FirstOrDefault() );
        }
    }
}